Jon Roberts
13219 Willow Forest Drive
Louisville, KY 40245
dbajonr@yahoo.com
502-241-6245 (home)
502-580-1688 (work)
EMPLOYMENT HISTORY
Humana
November 2001 - Present
Database Administrator
Designed and built Community Manager which is a web based report delivery application that has been tailored to meet the security requirements of Humana. The application is built primarily with PL/SQL packages and is delivered using Oracle 9iAS Release 1 (version 1.0.2.2.2a). Security is integrated with Humana's single sign on solution and uses Java Stored Procedures to communicate with Humana's Security API. Access control is controlled inside of Community Manager and it has role based Security.

Reports are run using Oracle Report Server via PL/SQL. The Reports are stored in the database as BLOBs. A scheduler has been written in PL/SQL to allow reports to run in batch in daily, weekly, business daily, or monthly intervals. The application also packages reports. A user may want to have 10 reports combined into a single PDF. The application can run each of the 10 reports independently in a multi threaded fashion and then a Java Stored Procedure combines all 10 PDF files into a single PDF. The single PDF is then stored in the database and the user can retrieve it.

Oracle Forms have also been incorporated into the site. Security is again integrated into Humana's Single Sign on solution using PL/SQL and Java stored procedures.  I wrote an Oracle Form to securely launch Forms within our application by first checking the rights of the user logged in.

There are 4 environments (Development, Test, Quality Assurance, and Production). Each environment is identical using the same hardware (2 CPU, 2 gig Web Server) each with their own database instance. Microsoft Source Safe is used for version control of PL/SQL to turn new code in each environment. There is also a large 8 processor server used to run just reports. 

Users can upload documents into the application and have the files stored in the database. A user can create content areas of files and share these content areas with other users.

Oracle Discoverer has also been added to the application. This has been done on a limited basis as Community Manager is focused more on Oracle Reports.

The databases were originally configured on Oracle 8i. Because of de-support of 8i this year, I have upgraded to 9i version 9.2.0.3. 

I am responsible for designing the application and integration of Security with Humana's single sign on solution. I wrote most of the "hard stuff" and two other developers focused on designing the optimal user interface. I am the DBA for all 4 database instances. I am the Discoverer Administrator which requires patching and configuring the server for optimal performance of Discoverer Viewer and Plus. I also upgraded users from 3i to 4i this year. I am the administrator for 9iAS. I research and patch every part of 9iAS used by Community Manager (Forms, Reports, Apache, SSL, etc)

I am currently researching 9iAS release 2 (version 9.0.2) and Application Server 10g (version 9.0.4).  I have done multiple test installations and migrated Forms and Reports to the new version.  I have researched migrating Oracle Discoverer to the new version as well.

CNET.COM (TechRepublic.com)
February 2001 - October 2001

Database Administrator
I was contracting at TechRepublic and was then hired full time. Just a month or two later, CNET.COM purchased TechRepublic.com. As an employee, I continued working on the CMS project that I started as a contractor from my previous employer (see TCI below).  I then started working on the Report System and Accucast.

Report System
TechRepublic used Microsoft SQL Server to run their web site. Daily reports were required to parse the previous day's web logs. These reports were scheduled independently of each other using Microsoft DTS packages. There were many problems with this as different jobs would conflict with each other and the logs were stored in one large table. Database logs were applied daily to the reporting server which compounded the scheduling problems the reporting system had.
I re-wrote this process by designing a scheduling procedure using Transact SQL. I partitioned these large tables as well. I designed a better way to calculate incremental changes and store the results in reporting summary tables. After I designed this and wrote a couple of reports, I trained 3 interns how to write the SQL for the reports. The reports were built using ASP and IIS. I also trained the other DBA at TechRepublic how to maintain this system and the partitioned tables.

Accucast
TechRepublic purchased Accucast from Socket Ware. This application is a mass mail delivery system. TechRepublic would send out millions of emails a day. This required database monitoring and enhancements to the Accucast code in order to achieve this. We were Socket Ware's largest customer at the time. I helped re-write their code to stop locking issues we were facing with their original code. 

Writing PL/SQL and publishing this using Oracle 9iAS Release 1 met reporting needs. The reporting needs were rather simple so I used the same type of scheduling system used in the Report System at TechRepublic to handle this. The report output was HTML only.

Technology Consulting Incorporated (TCI)
6/2000 - 2/2001
Database Administrator
While at TCI, I worked on their internal application called EPHRS. Employee Public Health Record System (EPHRS) was based on Oracle Application Server. It used Microsoft IIS as the web server. The application used generated PL/SQL code from Oracle Designer. It used Oracle 8i databases for Test, Development, and Production. 

I was responsible for the administration of the servers as well as upgrades. I did not design the application but was required to learn it to enhance it. The application was on the Internet so I spent a lot of time making sure the application was secure.

After finishing this project, I contracted at TechRepublic.com through TCI. I worked immediately on the CMS project.

CMS is a Content Management System that kept track of Word Documents containing articles for the Web Site. It was a 3rd party application. Two Oracle 8i databases were configured on Solaris for this application. I helped the contractors build referential integrity in their database model, as they didn't have any to begin with. The application utilized Intermedia to allow users to search the Word Documents for text. The initial installation of the databases used a single byte character set. Because Word Documents use high ascii value characters and the Word Documents were stored as CLOBs, I had to convert the databases to UTF8. 

I was the DBA on this project and provided technical leadership to the outside company that wrote CMS.  

After completing this project, I was hired full time for TechRepublic. Shortly after this, CNET.COM purchased TechRepublic.com.

Seven Lands Software
3/2000 - 6/2000
Database Administrator
I got into this small software development company with the expectations to continue using my Oracle skills. I quickly found out that this company wasn't doing very well financially and contracting there wasn't going to last long. 
I did work on a project that utilized openrowset function in SQL Server 7.0 to implement system that interacts with legacy Mainframe system.
I also performed the installation of a Sybase database at customer site. After the installation, I used BCP to begin testing this installation.
Louisville Gas and Electric (LG&E)
10/1997 - 3/2000
Database Administrator and Developer
LG&E was a great company. While there, I worked on CTS. Commodity Trading System (CTS) is a client server application that used Delphi as the front end and Oracle 8 databases in the back end. The application aided Traders in making energy-marketing deals. It also valued all deals on a nightly basis. A great deal of PL/SQL was written to support this application. 
CTS was already designed when I started working on it. I did help design enhancements and I wrote a great deal of code. The nightly valuation process was slow at one time and I was required to re-write this. I was able to greatly decrease the time it took to run the valuation. Some nights, it would take over 12 hours to complete. This application is still in use today and this valuation process takes 1 hour to complete now. This was achieved by multi threading the process to re-calculate the deals in the system. 
CTS ran on ran Oracle 7.3 on HP/UX with parallel server option and was later upgraded to Oracle 8.
I worked on the Gas Accounting system prior to CTS. On this project, I re-wrote many Crystal Reports to perform better and to summarize data correctly. I helped upgrade the database from SQL Server 6.0 on DEC Alpha to 6.5 on NT.
EDUCATION
University of Louisville, Louisville, KY Bachelor of Science in Business Administration, Concentration: Finance, December 1994, GPA: 3.31/ 4.0.
HONORS AND CERTIFICATIONS
* Oracle 9i Performance Tuning, Oracle 8 Database Administration, Oracle 8 Network Administration, and Oracle 8 Back and Recovery classes.
* NTR.NET Corporation Employee of the Month September 1996
* Golden Key National Honor Society and Dean's list
	
